APPS.PAY_DK_PR_ORG dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 85: FROM pay_payroll_actions

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

Line 210: ,pay_payroll_actions ppa1

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

Line 211: ,pay_payroll_actions ppa2

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

Line 297: ,pay_payroll_actions ppa1

293: ,pay_run_results prr
294: ,pay_input_values_f pivf
295: ,pay_element_types_f petf
296: ,pay_all_payrolls_f ppf
297: ,pay_payroll_actions ppa1
298: ,pay_payroll_actions ppa2
299: ,hr_all_organization_units haou
300: ,pay_action_interlocks pai
301:

Line 298: ,pay_payroll_actions ppa2

294: ,pay_input_values_f pivf
295: ,pay_element_types_f petf
296: ,pay_all_payrolls_f ppf
297: ,pay_payroll_actions ppa1
298: ,pay_payroll_actions ppa2
299: ,hr_all_organization_units haou
300: ,pay_action_interlocks pai
301:
302: WHERE

Line 395: ,pay_payroll_actions ppa1

391: ,pay_run_results prr
392: ,pay_input_values_f pivf
393: ,pay_element_types_f petf
394: ,pay_all_payrolls_f ppf
395: ,pay_payroll_actions ppa1
396: ,pay_payroll_actions ppa2
397: ,pay_element_set_members pesm
398: ,hr_all_organization_units haou
399: ,pay_action_interlocks pai

Line 396: ,pay_payroll_actions ppa2

392: ,pay_input_values_f pivf
393: ,pay_element_types_f petf
394: ,pay_all_payrolls_f ppf
395: ,pay_payroll_actions ppa1
396: ,pay_payroll_actions ppa2
397: ,pay_element_set_members pesm
398: ,hr_all_organization_units haou
399: ,pay_action_interlocks pai
400:

Line 469: ,pay_payroll_actions ppa

465:
466: -- the sql string to return
467: sqlstr := 'SELECT DISTINCT person_id
468: FROM per_people_f ppf
469: ,pay_payroll_actions ppa
470: WHERE ppa.payroll_action_id = :payroll_action_id
471: AND ppa.business_group_id = ppf.business_group_id
472: ORDER BY ppf.person_id';
473:

Line 770: pay_payroll_actions ppa,

766: payroll_action_id
767: INTO
768: l_payroll_action_id
769: FROM
770: pay_payroll_actions ppa,
771: fnd_conc_req_summary_v fcrs,
772: fnd_conc_req_summary_v fcrs1
773: WHERE
774: fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID