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 274: ,pay_payroll_actions ppa

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

Line 275: ,pay_payroll_actions ppa2

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

Line 276: ,pay_payroll_actions ppa3

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

Line 483: ,pay_payroll_actions ppa

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

Line 800: FROM pay_payroll_actions ppa,

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