APPS.PAY_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 276: -- variables are fetched from pay_payroll_actions --

272: -- Type : PROCEDURE --
273: -- Access : Private --
274: -- Description : Sets the global variables which will be used by --
275: -- assignment actions code. Values for global --
276: -- variables are fetched from pay_payroll_actions --
277: -- 'Legislative_parameters' column. --
278: -- --
279: -- Parameters : --
280: -- IN : p_payroll_action_id NUMBER --

Line 298: CURSOR csr_get_parameters(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

294: IS
295: l_procedure VARCHAR2(100) := null;
296: l_financial_year VARCHAR2(30);
297: --
298: CURSOR csr_get_parameters(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
299: IS
300: SELECT pay_core_utils.get_parameter('PAYROLL_ID'
301: ,legislative_parameters) payroll_id,
302: pay_core_utils.get_parameter('ASSIGNMENT_SET'

Line 310: FROM pay_payroll_actions ppa

306: pay_core_utils.get_parameter('FINANCIAL_YEAR'
307: ,legislative_parameters) financial_year,
308: pay_core_utils.get_parameter('PROCESSING_MODE'
309: ,legislative_parameters) processing_mode
310: FROM pay_payroll_actions ppa
311: WHERE ppa.payroll_action_id = p_payroll_action_id;
312:
313:
314: --

Line 408: FROM pay_payroll_actions ppa

404: --
405: CURSOR csr_pay_periods(c_start_date date)
406: IS
407: SELECT count(*)
408: FROM pay_payroll_actions ppa
409: , per_time_periods ptp
410: , pay_assignment_actions paa
411: , per_assignments_f paf
412: , pay_payrolls_f ppf

Line 529: ',pay_payroll_actions ppa' ||

525: --
526:
527: p_sql := ' SELECT distinct ppf.person_id' ||
528: ' FROM per_people_f ppf' ||
529: ',pay_payroll_actions ppa' ||
530: ' WHERE ppa.payroll_action_id = :payroll_action_id' ||
531: ' AND ppa.business_group_id = ppf.business_group_id' ||
532: ' ORDER BY ppf.person_id';
533:

Line 1008: pay_payroll_actions pay_action

1004: WHERE max_asg_act.assignment_id = c_assignment_id
1005: AND max_asg_act.action_sequence = (
1006: SELECT max(asg_action.action_sequence) action_sequence
1007: FROM pay_assignment_actions asg_action,
1008: pay_payroll_actions pay_action
1009: WHERE asg_action.assignment_id = c_assignment_id
1010: AND asg_action.payroll_action_id = pay_action.payroll_action_id
1011: AND asg_action.action_status = 'C'
1012: AND pay_action.action_status = 'C'