APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 164: from pay_payroll_actions

160: instr(LEGISLATIVE_PARAMETERS,'EXPIRATION_DATE='))+16,11),
161: -- to_char(add_months(sysdate,2),'DD-MON-YYYY') ) Expiration_date
162: fnd_date.date_to_canonical(add_months(sysdate,2)) ) Expiration_date
163: into p_expiration_date
164: from pay_payroll_actions
165: where PAYROLL_ACTION_ID = p_payroll_action_id;
166: --
167: RETURN p_expiration_date;
168: --

Line 183: from pay_payroll_actions

179: '0', null,
180: instr(LEGISLATIVE_PARAMETERS,'SUBMISSION_NUMBER='))+18,6),
181: 'NOLABL') Submission_number
182: into p_submission_number
183: from pay_payroll_actions
184: where PAYROLL_ACTION_ID = p_payroll_action_id;
185: --
186: hr_utility.set_location('bacsmgtp.get_submission_number',2);
187: RETURN p_submission_number;

Line 203: from pay_payroll_actions

199: select
200: -- substr(to_char(OVERRIDING_DD_DATE ,'DD-MON-YYYY'),1,11) effdate
201: substr(fnd_date.date_to_canonical(OVERRIDING_DD_DATE),1,11) effdate
202: into p_process_date
203: from pay_payroll_actions
204: where PAYROLL_ACTION_ID = p_payroll_action_id;
205: --
206: EXCEPTION when others then
207: hr_utility.set_message(801, 'Other error in get_process_date f');

Line 540: pay_payroll_actions ppa,

536: --find the difference b/w the dates
537: if p_entry_date = hr_general.start_of_time then
538: select default_dd_date into dd_date
539: from pay_assignment_actions paa,
540: pay_payroll_actions ppa,
541: per_time_periods ptp
542: where paa.assignment_action_id =
543: p_assignment_action_id
544: and ppa.payroll_action_id =

Line 549: from pay_payroll_actions ppa,

545: paa.payroll_action_id
546: and ptp.time_period_id = ppa.time_period_id;
547: else
548: select ppa.effective_date into eff_date
549: from pay_payroll_actions ppa,
550: pay_assignment_actions paa
551: where paa.assignment_action_id = p_assignment_action_id
552: and ppa.payroll_action_id = paa.payroll_action_id;
553: --

Line 633: from pay_payroll_actions ppa,

629: begin
630: --
631: -- dbms_output.put_line('Display effective date');
632: select ppa.effective_date into eff_date
633: from pay_payroll_actions ppa,
634: pay_assignment_actions paa
635: where paa.assignment_action_id = p_assignment_action_id
636: and ppa.payroll_action_id = paa.payroll_action_id;
637: --