APPS.PAY_CA_RL2_CAN_MAG dependencies on PAY_CA_EOY_RL2_TRANS_INFO_V

Line 600: FROM pay_ca_eoy_rl2_trans_info_v

596: nvl(transmitter_acct_contact_code,'000'),
597: nvl(transmitter_acct_contact_phone,'0000000'),
598: nvl(transmitter_acct_contact_extn,'0000'),
599: nvl(transmitter_acct_contact_lang,' ')
600: FROM pay_ca_eoy_rl2_trans_info_v
601: WHERE business_group_id = p_business_group_id
602: AND payroll_action_id = p_pact_id;
603:
604: l_trans_number varchar2(240);

Line 718: FROM pay_ca_eoy_rl2_trans_info_v

714: nvl(employer_add_line2,' '),
715: nvl(employer_city,' '),
716: nvl(employer_province,' '),
717: nvl(employer_postal_code,' ')
718: FROM pay_ca_eoy_rl2_trans_info_v
719: WHERE business_group_id = p_business_group_id
720: AND payroll_action_id = p_pact_id;
721:
722: l_employer_name varchar2(240);

Line 816: FROM pay_ca_eoy_rl2_trans_info_v

812: nvl(transmitter_acct_contact_code,'000'),
813: nvl(transmitter_acct_contact_phone,'0000000'),
814: nvl(transmitter_acct_contact_extn,'0000'),
815: nvl(transmitter_acct_contact_lang,' ')
816: FROM pay_ca_eoy_rl2_trans_info_v
817: WHERE business_group_id = p_business_group_id
818: AND payroll_action_id = p_pact_id;
819:
820: cursor c_rl_package_type is

Line 1354: pay_ca_eoy_rl2_trans_info_v

1350: nvl(employer_province,' '),
1351: nvl(employer_country,' '),
1352: nvl(employer_postal_code,' ')
1353: FROM
1354: pay_ca_eoy_rl2_trans_info_v
1355: WHERE
1356: business_group_id = p_business_group_id
1357: AND payroll_action_id = p_pact_id;
1358:

Line 1447: pay_ca_eoy_rl2_trans_info_v tran

1443: nvl(emp.negative_balance_flag, 'N'),
1444: emp.person_id
1445: FROM
1446: pay_ca_eoy_rl2_employee_info_v emp,
1447: pay_ca_eoy_rl2_trans_info_v tran
1448: WHERE
1449: emp.assignment_action_id = p_asg_action_id
1450: AND emp.payroll_action_id = tran.payroll_action_id;
1451: /* Commented for bug 8888411