APPS.PAY_CA_RL2_MAG dependencies on PAY_CA_EOY_RL2_TRANS_INFO_V

Line 303: pay_ca_eoy_rl2_trans_info_v tran,

299: index(emp.paa_arch,PAY_ASSIGNMENT_ACTIONS_PK)
300: use_hash(emp.ppa_arch,hoi,tran.ppa_arch)
301: */ distinct to_number(emp.person_id)
302: from pay_ca_eoy_rl2_employee_info_v emp,
303: pay_ca_eoy_rl2_trans_info_v tran,
304: pay_assignment_actions paa_arch,
305: pay_payroll_actions ppa_arch,
306: pay_payroll_actions ppa_mag,
307: hr_organization_information hoi

Line 625: FROM pay_ca_eoy_rl2_trans_info_v

621: nvl(transmitter_acct_contact_code,'000'),
622: nvl(transmitter_acct_contact_phone,'0000000'),
623: nvl(transmitter_acct_contact_extn,'0000'),
624: nvl(transmitter_acct_contact_lang,' ')
625: FROM pay_ca_eoy_rl2_trans_info_v
626: WHERE business_group_id = p_business_group_id
627: AND payroll_action_id = p_pact_id;
628:
629: l_trans_number varchar2(240);

Line 743: FROM pay_ca_eoy_rl2_trans_info_v

739: nvl(employer_add_line2,' '),
740: nvl(employer_city,' '),
741: nvl(employer_province,' '),
742: nvl(employer_postal_code,' ')
743: FROM pay_ca_eoy_rl2_trans_info_v
744: WHERE business_group_id = p_business_group_id
745: AND payroll_action_id = p_pact_id;
746:
747: l_employer_name varchar2(240);

Line 841: FROM pay_ca_eoy_rl2_trans_info_v

837: nvl(transmitter_acct_contact_code,'000'),
838: nvl(transmitter_acct_contact_phone,'0000000'),
839: nvl(transmitter_acct_contact_extn,'0000'),
840: nvl(transmitter_acct_contact_lang,' ')
841: FROM pay_ca_eoy_rl2_trans_info_v
842: WHERE business_group_id = p_business_group_id
843: AND payroll_action_id = p_pact_id;
844:
845: l_trans_number varchar2(240);

Line 1334: pay_ca_eoy_rl2_trans_info_v tran

1330:
1331: CURSOR c_employee_infor (p_asg_action_id IN number) IS
1332: SELECT nvl(emp.negative_balance_flag, 'N')
1333: FROM pay_ca_eoy_rl2_employee_info_v emp,
1334: pay_ca_eoy_rl2_trans_info_v tran
1335: WHERE emp.assignment_action_id = p_asg_action_id
1336: AND emp.payroll_action_id = tran.payroll_action_id;
1337:
1338: CURSOR c_employee_amend_infor (p_asg_action_id IN number) IS

Line 1342: pay_ca_eoy_rl2_trans_info_v tran

1338: CURSOR c_employee_amend_infor (p_asg_action_id IN number) IS
1339: SELECT nvl(emp.negative_balance_flag, 'N')
1340: FROM pay_ca_eoy_rl2_employee_info_v emp,
1341: pay_ca_eoy_rl2_emp_info2_v emp2,
1342: pay_ca_eoy_rl2_trans_info_v tran
1343: WHERE emp.assignment_action_id = p_asg_action_id
1344: AND emp.assignment_action_id = emp2.assignment_action_id
1345: AND emp.payroll_action_id = emp2.payroll_action_id
1346: AND emp.assignment_id = emp2.assignment_id

Line 1668: pay_ca_eoy_rl2_trans_info_v

1664: nvl(employer_province,' '),
1665: nvl(employer_country,' '),
1666: nvl(employer_postal_code,' ')
1667: FROM
1668: pay_ca_eoy_rl2_trans_info_v
1669: WHERE
1670: business_group_id = p_business_group_id
1671: AND payroll_action_id = p_pact_id;
1672:

Line 1710: pay_ca_eoy_rl2_trans_info_v tran

1706: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
1707: nvl(emp.negative_balance_flag, 'N'),
1708: emp.person_id
1709: FROM pay_ca_eoy_rl2_employee_info_v emp,
1710: pay_ca_eoy_rl2_trans_info_v tran
1711: WHERE emp.assignment_action_id = p_asg_action_id
1712: AND emp.payroll_action_id = tran.payroll_action_id;
1713:
1714: /*Created new cursor for RL2 Amendment PDF Purpose Bug#5046010*/

Line 1752: pay_ca_eoy_rl2_trans_info_v tran

1748: nvl(emp.negative_balance_flag, 'N'),
1749: emp.person_id
1750: FROM pay_ca_eoy_rl2_employee_info_v emp,
1751: pay_ca_eoy_rl2_emp_info2_v emp2,
1752: pay_ca_eoy_rl2_trans_info_v tran
1753: WHERE emp.assignment_action_id = p_asg_action_id
1754: AND emp.assignment_action_id = emp2.assignment_action_id
1755: AND emp.payroll_action_id = emp2.payroll_action_id
1756: AND emp.assignment_id = emp2.assignment_id

Line 5136: pay_ca_eoy_rl2_trans_info_v tran

5132: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
5133: nvl(emp.negative_balance_flag, 'N'),
5134: emp.person_id
5135: FROM pay_ca_eoy_rl2_employee_info_v emp,
5136: pay_ca_eoy_rl2_trans_info_v tran
5137: WHERE emp.assignment_action_id = p_asg_action_id
5138: AND emp.assignment_id = p_assignment_id
5139: AND emp.payroll_action_id = tran.payroll_action_id;
5140: