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

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

Line 280: ,pay_payroll_actions ppa2

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

Line 281: ,pay_payroll_actions ppa3

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

Line 476: ,pay_payroll_actions ppa

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

Line 798: FROM pay_payroll_actions ppa,

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

Line 977: , pay_payroll_actions ppa

973: SELECT fffunc.cn (decode (data_type, 'N'
974: , global_value, NULL))
975: INTO p_global_value
976: FROM ff_globals_f glb
977: , pay_payroll_actions ppa
978: WHERE glb.global_id = p_global_id
979: AND ppa.payroll_action_id = p_payroll_action_id
980: AND ppa.effective_date
981: BETWEEN glb.effective_start_date