APPS.PAY_NO_UNION_DUES dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 80: FROM pay_payroll_actions

76: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'FROM_DATE'))
77: ,fnd_date.canonical_to_date(PAY_NO_UNION_DUES.GET_PARAMETER(legislative_parameters,'TO_DATE'))
78: ,effective_date
79: ,business_group_id
80: FROM pay_payroll_actions
81: WHERE payroll_action_id = p_payroll_action_id;
82:
83: BEGIN
84:

Line 145: ,pay_payroll_actions ppa

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

Line 278: ,pay_payroll_actions ppa

274:
275: FROM
276: pay_assignment_actions assact
277: ,pay_assignment_actions assact1
278: ,pay_payroll_actions ppa
279: ,pay_payroll_actions ppa2
280: ,pay_payroll_actions ppa3
281: ,per_all_assignments_f asg
282: ,pay_element_types_f ele

Line 279: ,pay_payroll_actions ppa2

275: FROM
276: pay_assignment_actions assact
277: ,pay_assignment_actions assact1
278: ,pay_payroll_actions ppa
279: ,pay_payroll_actions ppa2
280: ,pay_payroll_actions ppa3
281: ,per_all_assignments_f asg
282: ,pay_element_types_f ele
283: ,pay_run_results prr

Line 280: ,pay_payroll_actions ppa3

276: pay_assignment_actions assact
277: ,pay_assignment_actions assact1
278: ,pay_payroll_actions ppa
279: ,pay_payroll_actions ppa2
280: ,pay_payroll_actions ppa3
281: ,per_all_assignments_f asg
282: ,pay_element_types_f ele
283: ,pay_run_results prr
284: ,pay_run_result_values prrv

Line 474: ,pay_payroll_actions ppa

470: ,prrv5.result_value res_val_5 -- Third Party Payee
471:
472: FROM
473: pay_assignment_actions assact
474: ,pay_payroll_actions ppa
475: ,per_all_assignments_f asg
476: ,per_all_people_f per
477: ,pay_element_types_f ele
478: ,pay_input_values_f inpv1

Line 795: FROM pay_payroll_actions ppa,

791: BEGIN
792:
793: SELECT payroll_action_id
794: INTO l_payroll_action_id
795: FROM pay_payroll_actions ppa,
796: fnd_conc_req_summary_v fcrs,
797: fnd_conc_req_summary_v fcrs1
798: WHERE fcrs.request_id = FND_GLOBAL.CONC_REQUEST_ID
799: AND fcrs.priority_request_id = fcrs1.priority_request_id