APPS.PAY_DK_PR_ELE dependencies on PAY_PAYROLL_ACTIONS

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

20: p_parameter_string IN VARCHAR2
21: ,p_token IN VARCHAR2
22: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
23: IS
24: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
25: l_start_pos NUMBER;
26: l_delimiter VARCHAR2(1):=' ';
27:
28: BEGIN

Line 85: pay_payroll_actions

81: ,PAY_DK_PR_ELE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
82: ,effective_date
83: ,business_group_id
84: FROM
85: pay_payroll_actions
86: WHERE
87: payroll_action_id = p_payroll_action_id;
88:
89: BEGIN

Line 208: ,pay_payroll_actions ppa1

204: per_all_assignments_f paaf
205: ,pay_all_payrolls_f ppf
206: ,pay_assignment_actions paa1
207: ,pay_assignment_actions paa2
208: ,pay_payroll_actions ppa1
209: ,pay_payroll_actions ppa2
210: ,pay_run_results prr
211: ,pay_input_values_f pivf
212: ,pay_element_types_f petf

Line 209: ,pay_payroll_actions ppa2

205: ,pay_all_payrolls_f ppf
206: ,pay_assignment_actions paa1
207: ,pay_assignment_actions paa2
208: ,pay_payroll_actions ppa1
209: ,pay_payroll_actions ppa2
210: ,pay_run_results prr
211: ,pay_input_values_f pivf
212: ,pay_element_types_f petf
213: ,pay_action_interlocks pai

Line 286: ,pay_payroll_actions ppa1

282: per_all_assignments_f paaf
283: ,pay_all_payrolls_f ppf
284: ,pay_assignment_actions paa1
285: ,pay_assignment_actions paa2
286: ,pay_payroll_actions ppa1
287: ,pay_payroll_actions ppa2
288: ,pay_run_results prr
289: ,pay_input_values_f pivf
290: ,pay_element_types_f petf

Line 287: ,pay_payroll_actions ppa2

283: ,pay_all_payrolls_f ppf
284: ,pay_assignment_actions paa1
285: ,pay_assignment_actions paa2
286: ,pay_payroll_actions ppa1
287: ,pay_payroll_actions ppa2
288: ,pay_run_results prr
289: ,pay_input_values_f pivf
290: ,pay_element_types_f petf
291: ,pay_action_interlocks pai

Line 378: ,pay_payroll_actions ppa1

374: ,pay_element_set_members pesm
375: ,pay_all_payrolls_f ppf
376: ,pay_assignment_actions paa1
377: ,pay_assignment_actions paa2
378: ,pay_payroll_actions ppa1
379: ,pay_payroll_actions ppa2
380: ,pay_run_results prr
381: ,pay_input_values_f pivf
382: ,pay_element_types_f petf

Line 379: ,pay_payroll_actions ppa2

375: ,pay_all_payrolls_f ppf
376: ,pay_assignment_actions paa1
377: ,pay_assignment_actions paa2
378: ,pay_payroll_actions ppa1
379: ,pay_payroll_actions ppa2
380: ,pay_run_results prr
381: ,pay_input_values_f pivf
382: ,pay_element_types_f petf
383: ,pay_action_interlocks pai

Line 453: ,pay_payroll_actions ppa

449:
450: -- the sql string to return
451: sqlstr := 'SELECT DISTINCT person_id
452: FROM per_people_f ppf
453: ,pay_payroll_actions ppa
454: WHERE ppa.payroll_action_id = :payroll_action_id
455: AND ppa.business_group_id = ppf.business_group_id
456: ORDER BY ppf.person_id';
457:

Line 738: pay_payroll_actions ppa,

734: payroll_action_id
735: INTO
736: l_payroll_action_id
737: FROM
738: pay_payroll_actions ppa,
739: fnd_conc_req_summary_v fcrs,
740: fnd_conc_req_summary_v fcrs1
741: WHERE
742: fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID