APPS.PAY_DK_PR_LE dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 87: FROM pay_payroll_actions

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

Line 211: ,pay_payroll_actions ppa1

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

Line 212: ,pay_payroll_actions ppa2

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

Line 302: ,pay_payroll_actions ppa1

298: ,pay_run_results prr
299: ,pay_input_values_f pivf
300: ,pay_element_types_f petf
301: ,pay_all_payrolls_f ppf
302: ,pay_payroll_actions ppa1
303: ,pay_payroll_actions ppa2
304: ,hr_all_organization_units haou1
305: ,hr_all_organization_units haou2
306: ,pay_action_interlocks pai

Line 303: ,pay_payroll_actions ppa2

299: ,pay_input_values_f pivf
300: ,pay_element_types_f petf
301: ,pay_all_payrolls_f ppf
302: ,pay_payroll_actions ppa1
303: ,pay_payroll_actions ppa2
304: ,hr_all_organization_units haou1
305: ,hr_all_organization_units haou2
306: ,pay_action_interlocks pai
307:

Line 410: ,pay_payroll_actions ppa1

406: ,pay_run_results prr
407: ,pay_input_values_f pivf
408: ,pay_element_types_f petf
409: ,pay_all_payrolls_f ppf
410: ,pay_payroll_actions ppa1
411: ,pay_payroll_actions ppa2
412: ,pay_element_set_members pesm
413: ,hr_all_organization_units haou1
414: ,hr_all_organization_units haou2

Line 411: ,pay_payroll_actions ppa2

407: ,pay_input_values_f pivf
408: ,pay_element_types_f petf
409: ,pay_all_payrolls_f ppf
410: ,pay_payroll_actions ppa1
411: ,pay_payroll_actions ppa2
412: ,pay_element_set_members pesm
413: ,hr_all_organization_units haou1
414: ,hr_all_organization_units haou2
415: ,pay_action_interlocks pai

Line 489: ,pay_payroll_actions ppa

485:
486: -- the sql string to return
487: sqlstr := 'SELECT DISTINCT person_id
488: FROM per_people_f ppf
489: ,pay_payroll_actions ppa
490: WHERE ppa.payroll_action_id = :payroll_action_id
491: AND ppa.business_group_id = ppf.business_group_id
492: ORDER BY ppf.person_id';
493:

Line 802: pay_payroll_actions ppa,

798: payroll_action_id
799: INTO
800: l_payroll_action_id
801: FROM
802: pay_payroll_actions ppa,
803: fnd_conc_req_summary_v fcrs,
804: fnd_conc_req_summary_v fcrs1
805: WHERE
806: fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID