APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_PAYROLL_ACTIONS

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

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

Line 162: FROM pay_payroll_actions

158: )
159: ) sort_order
160: ,effective_date
161: ,business_group_id bg_id
162: FROM pay_payroll_actions
163: WHERE payroll_action_id = p_payroll_action_id;
164:
165: lr_parameter_info csr_parameter_info%ROWTYPE;
166: l_proc VARCHAR2 (240)

Line 244: FROM pay_payroll_actions appa

240: ,csr_v_canonical_end_date DATE
241: )
242: IS
243: SELECT '1'
244: FROM pay_payroll_actions appa
245: ,pay_assignment_actions act
246: ,per_all_assignments_f as1
247: ,pay_payroll_actions ppa
248: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 247: ,pay_payroll_actions ppa

243: SELECT '1'
244: FROM pay_payroll_actions appa
245: ,pay_assignment_actions act
246: ,per_all_assignments_f as1
247: ,pay_payroll_actions ppa
248: WHERE ppa.payroll_action_id = p_payroll_action_id
249: AND appa.effective_date BETWEEN csr_v_canonical_start_date
250: AND csr_v_canonical_end_date
251: AND appa.action_type IN ('R', 'Q')

Line 432: ,pay_payroll_actions ppa

428:
429: p_sql :=
430: 'SELECT DISTINCT person_id
431: FROM per_people_f ppf
432: ,pay_payroll_actions ppa
433: WHERE ppa.payroll_action_id = :payroll_action_id
434: AND ppa.business_group_id = ppf.business_group_id
435: ORDER BY ppf.person_id';
436: g_payroll_action_id := p_payroll_action_id;

Line 840: FROM pay_payroll_actions appa

836: SELECT as1.person_id person_id
837: ,act.assignment_id assignment_id
838: ,act.assignment_action_id run_action_id
839: ,act.tax_unit_id legal_employer_id
840: FROM pay_payroll_actions appa
841: ,pay_assignment_actions act
842: ,per_all_assignments_f as1
843: ,pay_payroll_actions ppa
844: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 843: ,pay_payroll_actions ppa

839: ,act.tax_unit_id legal_employer_id
840: FROM pay_payroll_actions appa
841: ,pay_assignment_actions act
842: ,per_all_assignments_f as1
843: ,pay_payroll_actions ppa
844: WHERE ppa.payroll_action_id = p_payroll_action_id
845: AND appa.effective_date BETWEEN l_canonical_start_date
846: AND l_canonical_end_date
847: AND as1.person_id BETWEEN p_start_person AND p_end_person

Line 1802: l_date_earned pay_payroll_actions.date_earned%TYPE;

1798:
1799: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
1800: l_actid NUMBER;
1801: l_end_date per_time_periods.end_date%TYPE;
1802: l_date_earned pay_payroll_actions.date_earned%TYPE;
1803: l_effective_date pay_payroll_actions.effective_date%TYPE;
1804: l_start_date per_time_periods.start_date%TYPE;
1805: l_action_info_id pay_action_information.action_information_id%TYPE;
1806: l_ovn pay_action_information.object_version_number%TYPE;

Line 1803: l_effective_date pay_payroll_actions.effective_date%TYPE;

1799: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
1800: l_actid NUMBER;
1801: l_end_date per_time_periods.end_date%TYPE;
1802: l_date_earned pay_payroll_actions.date_earned%TYPE;
1803: l_effective_date pay_payroll_actions.effective_date%TYPE;
1804: l_start_date per_time_periods.start_date%TYPE;
1805: l_action_info_id pay_action_information.action_information_id%TYPE;
1806: l_ovn pay_action_information.object_version_number%TYPE;
1807: l_flag NUMBER := 0;

Line 4421: FROM pay_payroll_actions ppa

4417: THEN
4418: BEGIN
4419: SELECT payroll_action_id
4420: INTO l_payroll_action_id
4421: FROM pay_payroll_actions ppa
4422: ,fnd_conc_req_summary_v fcrs
4423: ,fnd_conc_req_summary_v fcrs1
4424: WHERE fcrs.request_id = fnd_global.conc_request_id
4425: AND fcrs.priority_request_id = fcrs1.priority_request_id