APPS.PAY_JP_ZENGIN_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 100: FROM pay_assignment_actions paa,

96: SELECT ppp.org_payment_method_id,
97: ppp.personal_payment_method_id,
98: ppp.value,
99: pa.assignment_number
100: FROM pay_assignment_actions paa,
101: pay_pre_payments ppp,
102: per_assignments pa
103: WHERE paa.payroll_action_id = p_payroll_action_id
104: AND ppp.pre_payment_id = paa.pre_payment_id

Line 225: FROM pay_assignment_actions paa, pay_pre_payments ppp

221: BEGIN
222: hr_utility.set_location('bacsmgtp.get_org_context',1);
223: SELECT ppp.org_payment_method_id
224: INTO p_org_payment_method_id
225: FROM pay_assignment_actions paa, pay_pre_payments ppp
226: WHERE paa.payroll_action_id = p_payroll_action_id
227: AND ppp.pre_payment_id = paa.pre_payment_id
228: AND ROWNUM = 1
229: ORDER BY ppp.org_payment_method_id;

Line 539: from pay_assignment_actions paa,

535: --
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

Line 550: pay_assignment_actions paa

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: --
554: -- dbms_output.put_line(eff_date);

Line 587: pay_assignment_actions paa,

583: CURSOR get_banks IS
584: select pea.segment8
585: from pay_org_payment_methods_f pop,
586: pay_personal_payment_methods_f ppp,
587: pay_assignment_actions paa,
588: pay_external_accounts pea,
589: pay_payment_types ppt
590: where paa.assignment_action_id =
591: p_assignment_action_id

Line 634: pay_assignment_actions paa

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: --
638: --

Line 643: from pay_assignment_actions

639: -- dbms_output.put_line(eff_date);
640: --
641: --dbms_output.put_line('Display assignment id');
642: select assignment_id into assignmt_id
643: from pay_assignment_actions
644: where assignment_action_id = p_assignment_action_id;
645: --
646: -- dbms_output.put_line(assignmt_id);
647: --