APPS.PAY_NO_TAX_LEVY dependencies on PAY_PAYROLL_ACTIONS

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

14: p_parameter_string IN VARCHAR2
15: ,p_token IN VARCHAR2
16: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
17: IS
18: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
19: l_start_pos NUMBER;
20: l_delimiter VARCHAR2(1):=' ';
21:
22: BEGIN

Line 74: FROM pay_payroll_actions

70: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,PAY_NO_TAX_LEVY.GET_PARAMETER(legislative_parameters,'THIRD_PARTY_PAYEE')
72: ,effective_date
73: ,business_group_id
74: FROM pay_payroll_actions
75: WHERE payroll_action_id = p_payroll_action_id;
76:
77: BEGIN
78:

Line 144: ,pay_payroll_actions ppa

140: END IF;
141: -- the sql string to return
142: sqlstr := 'SELECT DISTINCT person_id
143: FROM per_people_f ppf
144: ,pay_payroll_actions ppa
145: WHERE ppa.payroll_action_id = :payroll_action_id
146: AND ppa.business_group_id = ppf.business_group_id
147: ORDER BY ppf.person_id';
148:

Line 275: ,pay_payroll_actions ppa

271:
272: FROM
273: pay_assignment_actions assact
274: ,pay_assignment_actions assact1
275: ,pay_payroll_actions ppa
276: ,pay_payroll_actions ppa2
277: ,pay_payroll_actions ppa3
278: ,per_all_assignments_f asg
279: ,pay_element_types_f ele

Line 276: ,pay_payroll_actions ppa2

272: FROM
273: pay_assignment_actions assact
274: ,pay_assignment_actions assact1
275: ,pay_payroll_actions ppa
276: ,pay_payroll_actions ppa2
277: ,pay_payroll_actions ppa3
278: ,per_all_assignments_f asg
279: ,pay_element_types_f ele
280: ,pay_run_results prr

Line 277: ,pay_payroll_actions ppa3

273: pay_assignment_actions assact
274: ,pay_assignment_actions assact1
275: ,pay_payroll_actions ppa
276: ,pay_payroll_actions ppa2
277: ,pay_payroll_actions ppa3
278: ,per_all_assignments_f asg
279: ,pay_element_types_f ele
280: ,pay_run_results prr
281: ,pay_run_result_values prrv

Line 484: ,pay_payroll_actions ppa

480: ,prrv5.result_value res_val_5 -- Third Party Payee
481:
482: FROM
483: pay_assignment_actions assact
484: ,pay_payroll_actions ppa
485: ,per_all_assignments_f asg
486: ,per_all_people_f per
487: ,pay_element_types_f ele
488: ,pay_input_values_f inpv1

Line 802: FROM pay_payroll_actions ppa,

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