APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

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

49: FUNCTION get_parameter
50: (p_parameter_string IN VARCHAR2
51: ,p_token IN VARCHAR) RETURN VARCHAR2 IS
52: --
53: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
54: l_start_pos NUMBER;
55: l_delimiter VARCHAR2(1) := ' ';
56: --
57: BEGIN

Line 96: ,business_group_id BG_ID FROM pay_payroll_actions

92: TO_NUMBER ( GET_PARAMETER(legislative_parameters,'LE_ID') ) Legal
93: ,get_parameter(legislative_parameters,'VERSION') VERSION
94: ,GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
95: ,fnd_date.canonical_to_date(GET_PARAMETER(legislative_parameters,'DATE'))
96: ,business_group_id BG_ID FROM pay_payroll_actions
97: WHERE payroll_action_id = p_payroll_action_id;
98:
99: lr_parameter_info csr_parameter_info%ROWTYPE;
100:

Line 140: FROM pay_payroll_actions

136: SELECT business_group_id
137: ,legislative_parameters
138: ,get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
139: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE')) report_date
140: FROM pay_payroll_actions
141: WHERE payroll_action_id = p_payroll_action_id;
142: --
143: l_parameter_rec csr_parameters%ROWTYPE;
144: --

Line 240: ,pay_payroll_actions ppa

236: END IF;
237:
238: p_sql := 'SELECT DISTINCT person_id
239: FROM per_people_f ppf
240: ,pay_payroll_actions ppa
241: WHERE ppa.payroll_action_id = :payroll_action_id
242: AND ppa.business_group_id = ppf.business_group_id
243: ORDER BY ppf.person_id';
244:

Line 564: pay_payroll_actions ppa,

560: IS
561: SELECT sum(prrv.result_value) result
562: FROM
563: pay_assignment_actions paa,
564: pay_payroll_actions ppa,
565: per_time_periods ptp,
566: pay_run_results prr,
567: pay_run_result_values prrv,
568: pay_element_types_f pet,

Line 594: pay_payroll_actions ppa,

590: IS
591: SELECT sum(prrv.result_value) result
592: FROM
593: pay_assignment_actions paa,
594: pay_payroll_actions ppa,
595: pay_run_results prr,
596: pay_run_result_values prrv,
597: pay_element_types_f pet,
598: pay_element_type_extra_info pxi

Line 1181: pay_payroll_actions paa,

1177: pai_sal.action_information17 SSB_CODE_0038_PYQTD,
1178: pai_sal.action_information18 SSB_CODE_0040_YTD,
1179: pai_sal.action_information19 SSB_CODE_0041_YTD
1180: FROM
1181: pay_payroll_actions paa,
1182: pay_assignment_actions assg,
1183: pay_action_information pai,
1184: pay_action_information pai_sal
1185: WHERE

Line 1238: FROM pay_payroll_actions ppa,

1234: BEGIN
1235:
1236: SELECT payroll_action_id
1237: INTO l_payroll_action_id
1238: FROM pay_payroll_actions ppa,
1239: fnd_conc_req_summary_v fcrs,
1240: fnd_conc_req_summary_v fcrs1
1241: WHERE fcrs.request_id = fnd_global.conc_request_id
1242: AND fcrs.priority_request_id = fcrs1.priority_request_id