APPS.PAY_FR_DUCS dependencies on PAY_PAYROLL_ACTIONS

Line 19: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

15:
16: g_package constant varchar2(30):= 'pay_fr_ducs';
17:
18: g_business_group_id per_business_Groups.business_group_id%TYPE;
19: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
20:
21: g_company_id hr_all_organization_units.organization_id%TYPE;
22: g_period_type varchar2(60);
23: g_period_start_date date;

Line 43: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

39: p_parameter_string in varchar2
40: ,p_token in varchar2
41: ,p_segment_number in number default null ) RETURN varchar2
42: IS
43: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
44: l_start_pos NUMBER;
45: l_delimiter varchar2(1):=' ';
46: l_proc VARCHAR2(60):= g_package||' get parameter ';
47: BEGIN

Line 98: FROM pay_payroll_actions

94: pay_fr_ducs.get_parameter(legislative_parameters, 'COMPANY_ID'))
95: ,pay_fr_ducs.get_parameter(legislative_parameters, 'PERIOD_TYPE')
96: ,effective_date
97: ,business_group_id
98: FROM pay_payroll_actions
99: WHERE payroll_action_id = p_payroll_action_id;
100: --
101: l_proc VARCHAR2(60):= g_package||' get_all_parameters ';
102:

Line 148: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

144: -- Local Variable
145:
146: l_proc VARCHAR2(60) := g_package||' range_cursor ';
147:
148: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
149: duplicate EXCEPTION;
150:
151: l_year varchar2(10);
152: l_quarter varchar2(10);

Line 163: FROM pay_payroll_actions payact

159: --
160:
161: CURSOR c_existing_archive (p_company_id_chr in varchar2) is
162: SELECT payact.payroll_action_id
163: FROM pay_payroll_actions payact
164: ,pay_action_information ref_actinfo
165: WHERE payact.payroll_action_id = ref_actinfo.action_context_id
166: and ref_actinfo.action_information_category = 'FR_DUCS_REFERENCE_INFO'
167: and ref_actinfo.action_context_type = 'PA'

Line 228: ,pay_payroll_actions ppa

224: hr_utility.set_location('Step ' || l_proc, 30);
225:
226: sqlstr := 'SELECT DISTINCT person_id
227: FROM per_people_f ppf
228: ,pay_payroll_actions ppa
229: WHERE ppa.payroll_action_id = :payroll_action_id
230: AND ppa.business_group_id = ppf.business_group_id
231: ORDER BY ppf.person_id';
232:

Line 286: , pay_payroll_actions payact

282: , assact.assignment_action_id
283: , assact.tax_unit_id establishment_id
284: , payact.action_type
285: FROM pay_assignment_actions assact
286: , pay_payroll_actions payact
287: , hr_organization_information cmp_check
288: WHERE assact.source_action_id is null
289: AND assact.action_status = 'C'
290: AND assact.payroll_action_id = payact.payroll_action_id

Line 330: , pay_payroll_actions payact

326: FROM pay_population_ranges pop
327: , per_periods_of_service pos
328: , per_all_assignments_f asg
329: , pay_assignment_actions assact
330: , pay_payroll_actions payact
331: , hr_organization_information cmp_check
332: WHERE pop.payroll_action_id = p_payroll_action_id
333: and pop.chunk_number = p_chunk
334: and asg.business_group_id+0 = g_business_group_id

Line 518: , pay_payroll_actions payact

514: locked_assact.assignment_action_id id,
515: locked_assact.tax_unit_id
516: FROM pay_action_interlocks interlock
517: , pay_assignment_actions locked_assact
518: , pay_payroll_actions payact
519: WHERE interlock.locking_action_id = p_assignment_action_id
520: AND interlock.locked_action_id = locked_assact.assignment_action_id
521: AND locked_assact.payroll_action_id = payact.payroll_action_id;
522: --

Line 527: , pay_payroll_actions rev_payact

523: CURSOR csr_locking_reversal (p_run_act_id number) is
524: SELECT 1 /* if the run action is reversed exclude it */
525: FROM pay_action_interlocks rev_interlock
526: , pay_assignment_actions rev_assact
527: , pay_payroll_actions rev_payact
528: WHERE rev_interlock.locked_action_id = p_run_act_id
529: AND rev_interlock.locking_action_id = rev_assact.assignment_action_id
530: AND rev_assact.action_status = 'C'
531: AND rev_payact.payroll_action_id = rev_assact.payroll_action_id

Line 1177: FROM pay_payroll_actions payact

1173: , pay_action_information contrib
1174: WHERE
1175: assact.payroll_action_id in
1176: (SELECT payroll_action_id
1177: FROM pay_payroll_actions payact
1178: , pay_action_information actinfo
1179: WHERE payact.effective_date between g_period_start_date
1180: and g_effective_date
1181: and payact.payroll_action_id = actinfo.action_context_id

Line 1216: FROM pay_payroll_actions payact

1212: , round(sum(fnd_number.canonical_to_number(contrib.action_information5))) base
1213: , fnd_number.canonical_to_number(contrib.action_information6) rate
1214: , sum(fnd_number.canonical_to_number(contrib.action_information7)) pay_value
1215: , count(distinct assact.assignment_id) number_of_employees
1216: FROM pay_payroll_actions payact
1217: , pay_assignment_actions assact
1218: , pay_action_information contrib
1219: WHERE assact.payroll_action_id = payact.payroll_action_id
1220: and payact.report_type = 'DUCS_ARCHIVE'

Line 1458: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

1454: l_proc VARCHAR2(60):= g_package||' deinitialize_code ';
1455: duplicate EXCEPTION;
1456:
1457: -- Local Variable
1458: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1459:
1460: l_year varchar2(10);
1461: l_quarter varchar2(10);
1462: l_month varchar2(10);

Line 1518: FROM pay_payroll_actions payact

1514: -----------
1515:
1516: CURSOR c_existing_archive (p_company_id_chr in varchar2) is
1517: SELECT payact.payroll_action_id
1518: FROM pay_payroll_actions payact
1519: ,pay_action_information ref_actinfo
1520: WHERE payact.payroll_action_id = ref_actinfo.action_context_id
1521: and ref_actinfo.action_information_category = 'FR_DUCS_REFERENCE_INFO'
1522: and ref_actinfo.action_context_type = 'PA'