APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_PAYROLL_ACTIONS

Line 53: l_parameter pay_payroll_actions.legislative_parameters%type := null;

49: p_token in varchar2,
50: p_segment_number in number default null
51: )
52: return varchar2 is
53: l_parameter pay_payroll_actions.legislative_parameters%type := null;
54: l_start_pos number;
55: l_delimiter varchar2 (1) := ' ';
56: l_proc varchar2 (240) := g_package || ' get parameter ';
57: begin

Line 119: from pay_payroll_actions

115: pay_fi_archive_psta.get_parameter (legislative_parameters, 'LOCAL_UNIT_ID'),
116: pay_fi_archive_psta.get_parameter (legislative_parameters, 'YEAR_RPT'),
117: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_TYPE'),
118: pay_fi_archive_psta.get_parameter (legislative_parameters, 'PAYROLL_ID'), effective_date, business_group_id
119: from pay_payroll_actions
120: where payroll_action_id = p_payroll_action_id;
121:
122: l_proc varchar2 (240) := g_package || ' GET_ALL_PARAMETERS ';
123: --

Line 215: ,pay_payroll_actions ppa

211:
212: p_sql :=
213: 'SELECT DISTINCT person_id
214: FROM per_people_f ppf
215: ,pay_payroll_actions ppa
216: WHERE ppa.payroll_action_id = :payroll_action_id
217: AND ppa.business_group_id = ppf.business_group_id
218: ORDER BY ppf.person_id';
219: --

Line 372: from pay_payroll_actions appa,

368: select paaf.person_id, paaf.primary_flag, act.assignment_id assignment_id, act.assignment_action_id run_action_id,
369: act1.assignment_action_id
370: prepaid_action_id, appa.effective_date, appa.payroll_action_id,
371: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
372: from pay_payroll_actions appa,
373: pay_payroll_actions appa2,
374: pay_assignment_actions act,
375: pay_assignment_actions act1,
376: pay_action_interlocks pai,

Line 373: pay_payroll_actions appa2,

369: act1.assignment_action_id
370: prepaid_action_id, appa.effective_date, appa.payroll_action_id,
371: appa2.payroll_action_id payactid, hsck.segment2 local_unit_id
372: from pay_payroll_actions appa,
373: pay_payroll_actions appa2,
374: pay_assignment_actions act,
375: pay_assignment_actions act1,
376: pay_action_interlocks pai,
377: per_all_assignments_f paaf,

Line 409: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%type

405: order by person_id, assignment_id, payroll_action_id, prepaid_action_id;
406:
407: /* Cursor to get the time period details for the given payroll action id */
408: cursor csr_time_period_details (
409: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%type
410: ) is
411: select papf.payroll_id, papf.payroll_name, ptp.start_date, ptp.end_date, ptp.period_name, ptp.period_type,
412: ptp.regular_payment_date, ptp.time_period_id
413: from pay_payroll_actions ppa, per_time_periods ptp, pay_all_payrolls_f papf

Line 413: from pay_payroll_actions ppa, per_time_periods ptp, pay_all_payrolls_f papf

409: csr_v_payroll_action_id pay_payroll_actions.payroll_action_id%type
410: ) is
411: select papf.payroll_id, papf.payroll_name, ptp.start_date, ptp.end_date, ptp.period_name, ptp.period_type,
412: ptp.regular_payment_date, ptp.time_period_id
413: from pay_payroll_actions ppa, per_time_periods ptp, pay_all_payrolls_f papf
414: where ptp.time_period_id = ppa.time_period_id
415: and ppa.payroll_id = papf.payroll_id
416: and ppa.payroll_action_id = csr_v_payroll_action_id;
417: