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 267: FROM pay_payroll_actions appa

263: ,csr_v_canonical_end_date DATE
264: )
265: IS
266: SELECT '1'
267: FROM pay_payroll_actions appa
268: ,pay_assignment_actions act
269: ,per_all_assignments_f as1
270: ,pay_payroll_actions ppa
271: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 270: ,pay_payroll_actions ppa

266: SELECT '1'
267: FROM pay_payroll_actions appa
268: ,pay_assignment_actions act
269: ,per_all_assignments_f as1
270: ,pay_payroll_actions ppa
271: WHERE ppa.payroll_action_id = p_payroll_action_id
272: AND appa.effective_date BETWEEN csr_v_canonical_start_date
273: AND csr_v_canonical_end_date
274: AND appa.action_type IN ('R', 'Q')

Line 296: ,pay_payroll_actions ppa

292:
293: p_sql :=
294: 'SELECT DISTINCT person_id
295: FROM per_people_f ppf
296: ,pay_payroll_actions ppa
297: WHERE ppa.payroll_action_id = :payroll_action_id
298: AND ppa.business_group_id = ppf.business_group_id
299: ORDER BY ppf.person_id';
300: g_payroll_action_id := p_payroll_action_id;

Line 466: FROM pay_payroll_actions appa

462: IS
463: SELECT as1.person_id person_id
464: ,act.assignment_id assignment_id
465: ,act.assignment_action_id run_action_id
466: FROM pay_payroll_actions appa
467: ,pay_assignment_actions act
468: ,per_all_assignments_f as1
469: ,pay_payroll_actions ppa
470: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 469: ,pay_payroll_actions ppa

465: ,act.assignment_action_id run_action_id
466: FROM pay_payroll_actions appa
467: ,pay_assignment_actions act
468: ,per_all_assignments_f as1
469: ,pay_payroll_actions ppa
470: WHERE ppa.payroll_action_id = p_payroll_action_id
471: AND appa.effective_date BETWEEN l_canonical_start_date
472: AND l_canonical_end_date
473: AND as1.person_id BETWEEN p_start_person AND p_end_person

Line 953: l_date_earned pay_payroll_actions.date_earned%TYPE;

949:
950: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
951: l_actid NUMBER;
952: l_end_date per_time_periods.end_date%TYPE;
953: l_date_earned pay_payroll_actions.date_earned%TYPE;
954: l_effective_date pay_payroll_actions.effective_date%TYPE;
955: l_start_date per_time_periods.start_date%TYPE;
956: l_action_info_id pay_action_information.action_information_id%TYPE;
957: l_ovn pay_action_information.object_version_number%TYPE;

Line 954: l_effective_date pay_payroll_actions.effective_date%TYPE;

950: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
951: l_actid NUMBER;
952: l_end_date per_time_periods.end_date%TYPE;
953: l_date_earned pay_payroll_actions.date_earned%TYPE;
954: l_effective_date pay_payroll_actions.effective_date%TYPE;
955: l_start_date per_time_periods.start_date%TYPE;
956: l_action_info_id pay_action_information.action_information_id%TYPE;
957: l_ovn pay_action_information.object_version_number%TYPE;
958: l_flag NUMBER := 0;

Line 1959: FROM pay_payroll_actions ppa

1955: THEN
1956: BEGIN
1957: SELECT payroll_action_id
1958: INTO l_payroll_action_id
1959: FROM pay_payroll_actions ppa
1960: ,fnd_conc_req_summary_v fcrs
1961: ,fnd_conc_req_summary_v fcrs1
1962: WHERE fcrs.request_id = fnd_global.conc_request_id
1963: AND fcrs.priority_request_id = fcrs1.priority_request_id