APPS.PAY_SE_ALECTA dependencies on PAY_PAYROLL_ACTIONS

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

40: ,p_segment_number IN NUMBER DEFAULT NULL
41: )
42: RETURN VARCHAR2
43: IS
44: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
45: l_start_pos NUMBER;
46: l_delimiter VARCHAR2 (1) := ' ';
47: l_proc VARCHAR2 (40) := g_package || ' get parameter ';
48: BEGIN

Line 148: FROM pay_payroll_actions

144: )
145: ) production
146: ,effective_date effective_date
147: ,business_group_id bg_id
148: FROM pay_payroll_actions
149: WHERE payroll_action_id = p_payroll_action_id;
150:
151: lr_parameter_info csr_parameter_info%ROWTYPE;
152: l_proc VARCHAR2 (240)

Line 307: FROM pay_payroll_actions appa

303: ,csr_v_canonical_end_date DATE
304: )
305: IS
306: SELECT '1'
307: FROM pay_payroll_actions appa
308: ,pay_assignment_actions act
309: ,per_all_assignments_f as1
310: ,pay_payroll_actions ppa
311: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 310: ,pay_payroll_actions ppa

306: SELECT '1'
307: FROM pay_payroll_actions appa
308: ,pay_assignment_actions act
309: ,per_all_assignments_f as1
310: ,pay_payroll_actions ppa
311: WHERE ppa.payroll_action_id = p_payroll_action_id
312: AND appa.effective_date BETWEEN csr_v_canonical_start_date
313: AND csr_v_canonical_end_date
314: AND appa.action_type IN ('R', 'Q')

Line 336: ,pay_payroll_actions ppa

332:
333: p_sql :=
334: 'SELECT DISTINCT person_id
335: FROM per_people_f ppf
336: ,pay_payroll_actions ppa
337: WHERE ppa.payroll_action_id = :payroll_action_id
338: AND ppa.business_group_id = ppf.business_group_id
339: ORDER BY ppf.person_id';
340: g_payroll_action_id := p_payroll_action_id;

Line 506: FROM pay_payroll_actions appa

502: IS
503: SELECT as1.person_id person_id
504: ,act.assignment_id assignment_id
505: ,act.assignment_action_id run_action_id
506: FROM pay_payroll_actions appa
507: ,pay_assignment_actions act
508: ,per_all_assignments_f as1
509: ,pay_payroll_actions ppa
510: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 509: ,pay_payroll_actions ppa

505: ,act.assignment_action_id run_action_id
506: FROM pay_payroll_actions appa
507: ,pay_assignment_actions act
508: ,per_all_assignments_f as1
509: ,pay_payroll_actions ppa
510: WHERE ppa.payroll_action_id = p_payroll_action_id
511: AND appa.effective_date BETWEEN l_canonical_start_date
512: AND l_canonical_end_date
513: AND as1.person_id BETWEEN p_start_person AND p_end_person

Line 993: l_date_earned pay_payroll_actions.date_earned%TYPE;

989:
990: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
991: l_actid NUMBER;
992: l_end_date per_time_periods.end_date%TYPE;
993: l_date_earned pay_payroll_actions.date_earned%TYPE;
994: l_effective_date pay_payroll_actions.effective_date%TYPE;
995: l_start_date per_time_periods.start_date%TYPE;
996: l_action_info_id pay_action_information.action_information_id%TYPE;
997: l_ovn pay_action_information.object_version_number%TYPE;

Line 994: l_effective_date pay_payroll_actions.effective_date%TYPE;

990: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
991: l_actid NUMBER;
992: l_end_date per_time_periods.end_date%TYPE;
993: l_date_earned pay_payroll_actions.date_earned%TYPE;
994: l_effective_date pay_payroll_actions.effective_date%TYPE;
995: l_start_date per_time_periods.start_date%TYPE;
996: l_action_info_id pay_action_information.action_information_id%TYPE;
997: l_ovn pay_action_information.object_version_number%TYPE;
998: l_flag NUMBER := 0;

Line 2181: FROM pay_payroll_actions ppa

2177: THEN
2178: BEGIN
2179: SELECT payroll_action_id
2180: INTO l_payroll_action_id
2181: FROM pay_payroll_actions ppa
2182: ,fnd_conc_req_summary_v fcrs
2183: ,fnd_conc_req_summary_v fcrs1
2184: WHERE fcrs.request_id = fnd_global.conc_request_id
2185: AND fcrs.priority_request_id = fcrs1.priority_request_id