APPS.PAY_NO_ARC_RSEA_07 dependencies on PAY_PAYROLL_ACTIONS

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

208: p_parameter_string IN VARCHAR2
209: ,p_token IN VARCHAR2
210: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
211: IS
212: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
213: l_start_pos NUMBER;
214: l_delimiter VARCHAR2(1):=' ';
215: l_proc VARCHAR2(40):= g_package||' get parameter ';
216: BEGIN

Line 263: FROM pay_payroll_actions

259: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'LOCAL_UNIT_NAME')
260: ,PAY_NO_ARC_RSEA_07.GET_PARAMETER(legislative_parameters,'ARCHIVE')
261: ,effective_date
262: ,business_group_id
263: FROM pay_payroll_actions
264: WHERE payroll_action_id = p_payroll_action_id;
265: --
266: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
267: --

Line 427: FROM pay_payroll_actions ppa

423: p_legal_employer_id NUMBER,
424: l_start_date DATE,
425: l_end_date DATE) IS
426: SELECT DISTINCT act.assignment_id assignment_id
427: FROM pay_payroll_actions ppa
428: ,pay_payroll_actions appa
429: ,pay_payroll_actions appa2
430: ,pay_assignment_actions act
431: ,pay_assignment_actions act1

Line 428: ,pay_payroll_actions appa

424: l_start_date DATE,
425: l_end_date DATE) IS
426: SELECT DISTINCT act.assignment_id assignment_id
427: FROM pay_payroll_actions ppa
428: ,pay_payroll_actions appa
429: ,pay_payroll_actions appa2
430: ,pay_assignment_actions act
431: ,pay_assignment_actions act1
432: ,pay_action_interlocks pai

Line 429: ,pay_payroll_actions appa2

425: l_end_date DATE) IS
426: SELECT DISTINCT act.assignment_id assignment_id
427: FROM pay_payroll_actions ppa
428: ,pay_payroll_actions appa
429: ,pay_payroll_actions appa2
430: ,pay_assignment_actions act
431: ,pay_assignment_actions act1
432: ,pay_action_interlocks pai
433: ,per_all_assignments_f as1

Line 480: FROM pay_payroll_actions ppa

476: ,p_local_unit_id NUMBER
477: ,l_start_date DATE
478: ,l_end_date DATE) IS
479: SELECT DISTINCT act.assignment_id assignment_id
480: FROM pay_payroll_actions ppa
481: ,pay_payroll_actions appa
482: ,pay_payroll_actions appa2
483: ,pay_assignment_actions act
484: ,pay_assignment_actions act1

Line 481: ,pay_payroll_actions appa

477: ,l_start_date DATE
478: ,l_end_date DATE) IS
479: SELECT DISTINCT act.assignment_id assignment_id
480: FROM pay_payroll_actions ppa
481: ,pay_payroll_actions appa
482: ,pay_payroll_actions appa2
483: ,pay_assignment_actions act
484: ,pay_assignment_actions act1
485: ,pay_action_interlocks pai

Line 482: ,pay_payroll_actions appa2

478: ,l_end_date DATE) IS
479: SELECT DISTINCT act.assignment_id assignment_id
480: FROM pay_payroll_actions ppa
481: ,pay_payroll_actions appa
482: ,pay_payroll_actions appa2
483: ,pay_assignment_actions act
484: ,pay_assignment_actions act1
485: ,pay_action_interlocks pai
486: ,per_all_assignments_f as1

Line 696: ,pay_payroll_actions ppa

692: END IF;
693: --
694: p_sql :='SELECT DISTINCT person_id
695: FROM per_people_f ppf
696: ,pay_payroll_actions ppa
697: WHERE ppa.payroll_action_id = :payroll_action_id
698: AND ppa.business_group_id = ppf.business_group_id
699: ORDER BY ppf.person_id';
700: --

Line 1443: from pay_payroll_actions ppa,

1439: IF p_payroll_action_id is null then
1440: BEGIN
1441: SELECT payroll_action_id
1442: into l_payroll_action_id
1443: from pay_payroll_actions ppa,
1444: fnd_conc_req_summary_v fcrs,
1445: fnd_conc_req_summary_v fcrs1
1446: WHERE fcrs.request_id = fnd_global.conc_request_id
1447: and fcrs.priority_request_id = fcrs1.priority_request_id

Line 1956: from pay_payroll_actions ppa,

1952: IF p_payroll_action_id is null then
1953: BEGIN
1954: SELECT payroll_action_id
1955: into l_payroll_action_id
1956: from pay_payroll_actions ppa,
1957: fnd_conc_req_summary_v fcrs,
1958: fnd_conc_req_summary_v fcrs1
1959: WHERE fcrs.request_id = fnd_global.conc_request_id
1960: and fcrs.priority_request_id = fcrs1.priority_request_id