APPS.PAY_NO_PACCR_PKG dependencies on PAY_PAYROLL_ACTIONS

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

15: p_parameter_string IN VARCHAR2
16: ,p_token IN VARCHAR2
17: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
18: IS
19: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
20: l_start_pos NUMBER;
21: l_delimiter VARCHAR2(1):=' ';
22:
23: BEGIN

Line 88: FROM pay_payroll_actions

84: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_START_DATE'))
85: ,fnd_date.canonical_to_date(PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'REPORT_END_DATE'))
86: ,PAY_NO_PACCR_PKG.GET_PARAMETER(legislative_parameters,'ARCHIVE')
87: ,business_group_id
88: FROM pay_payroll_actions
89: WHERE payroll_action_id = p_payroll_action_id;
90:
91: l_proc VARCHAR2(240):= g_package||'.GET_ALL_PARAMETERS ';
92: --

Line 219: ,pay_payroll_actions ppa

215:
216: -- The sql string to return
217: sqlstr := 'SELECT DISTINCT person_id
218: FROM per_people_f ppf
219: ,pay_payroll_actions ppa
220: WHERE ppa.payroll_action_id = :payroll_action_id
221: AND ppa.business_group_id = ppf.business_group_id
222: ORDER BY ppf.person_id';
223:

Line 399: pay_payroll_actions ppa

395: ,pc.balance_or_cost COST_OR_BAL
396: ,papf.full_name EMP_NAME
397: ,prr.run_result_id RR_ID -- not in use
398: FROM
399: pay_payroll_actions ppa
400: , pay_payrolls_f ppf
401: , per_all_people_f papf
402: , per_all_assignments_f paaf
403: , pay_assignment_actions paa

Line 1014: FROM pay_payroll_actions ppa,

1010: IF p_payroll_action_id IS NULL THEN
1011: BEGIN
1012: SELECT payroll_action_id
1013: INTO l_payroll_action_id
1014: FROM pay_payroll_actions ppa,
1015: fnd_conc_req_summary_v fcrs,
1016: fnd_conc_req_summary_v fcrs1
1017: WHERE fcrs.request_id = fnd_global.conc_request_id
1018: AND fcrs.priority_request_id = fcrs1.priority_request_id

Line 1372: FROM pay_payroll_actions ppa,

1368: --
1369: BEGIN
1370: SELECT payroll_action_id
1371: INTO l_payroll_action_id
1372: FROM pay_payroll_actions ppa,
1373: fnd_conc_req_summary_v fcrs,
1374: fnd_conc_req_summary_v fcrs1
1375: WHERE fcrs.request_id = fnd_global.conc_request_id
1376: AND fcrs.priority_request_id = fcrs1.priority_request_id