APPS.PAY_NZ_EFT dependencies on PER_TIME_PERIODS

Line 24: ** to fetch default_dd_date from the per_time_periods

20: ** like BATCH_DUE_DATE,BATCH_CREATION_DATE
21: ** NBNZ_HASH_ACCT and REG_EMPLOYER in the XML
22: ** generated for each assignment.
23: ** 05 DEC 2008 PMATAMSR 7614146 A new cursor get_batch_due_date is added
24: ** to fetch default_dd_date from the per_time_periods
25: ** as batch_due_date to the NZ Direct Credit XML report.
26: */
27:
28: g_debug BOOLEAN := hr_utility.debug_enabled;

Line 86: per_time_periods ptp

82: FROM pay_assignment_actions paa,
83: pay_pre_payments ppp,
84: pay_payroll_actions ppa,
85: pay_action_interlocks pai,
86: per_time_periods ptp
87: WHERE ppp.pre_payment_id = c_pre_payment_id
88: AND pai.locking_action_id = ppp.assignment_action_id
89: AND paa.assignment_action_id = pai.locked_action_id
90: AND ppa.payroll_action_id = paa.payroll_action_id

Line 128: /*Bug#7614146 -Default_dd_date from per_time_periods table is fetched as

124: OPEN get_legal_employer_info(l_payroll_action_id,l_assignment_action_id);
125: FETCH get_legal_employer_info INTO l_legal_employer;
126: CLOSE get_legal_employer_info;
127:
128: /*Bug#7614146 -Default_dd_date from per_time_periods table is fetched as
129: * Batch Due date into the XML report*/
130: OPEN get_batch_due_date(l_pre_pay_id);
131: FETCH get_batch_due_date INTO l_batch_due_date;
132: CLOSE get_batch_due_date;