APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_CA_EOY_RL2_TRANS_INFO_V

Line 190: FROM pay_ca_eoy_rl2_trans_info_v

186: nvl(transmitter_name,' '),
187: nvl(transmitter_package_type,'0'),
188: nvl(source_of_slips,' '),
189: nvl(transmitter_address_line1,' ')
190: FROM pay_ca_eoy_rl2_trans_info_v
191: WHERE business_group_id = p_business_group_id
192: AND payroll_action_id = p_pactid;
193:
194: BEGIN

Line 313: pay_ca_eoy_rl2_trans_info_v tran,

309:
310: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 20);
311: p_sqlstr := 'select distinct to_number(emp.person_id)
312: from pay_ca_eoy_rl2_employee_info_v emp,
313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,
315: pay_payroll_actions ppa_arch,
316: pay_payroll_actions ppa_mag,
317: hr_organization_information hoi

Line 509: FROM pay_ca_eoy_rl2_trans_info_v

505: p_pact_id number) IS
506: SELECT nvl(employer_name,' '),
507: nvl(quebec_business_number,'0000000000 0000'),
508: nvl(employer_add_line1,' ')
509: FROM pay_ca_eoy_rl2_trans_info_v
510: WHERE business_group_id = p_business_group_id
511: AND payroll_action_id = p_pact_id;
512:
513: CURSOR c_paa_update_check (cp_locking_asg_act_id number) IS

Line 833: FROM pay_ca_eoy_rl2_trans_info_v

829: nvl(transmitter_acct_contact_code,'000'),
830: nvl(transmitter_acct_contact_phone,'0000000'),
831: nvl(transmitter_acct_contact_extn,'0000'),
832: nvl(transmitter_acct_contact_lang,' ')
833: FROM pay_ca_eoy_rl2_trans_info_v
834: WHERE business_group_id = p_business_group_id
835: AND payroll_action_id = p_pact_id;
836:
837: l_trans_number varchar2(240);

Line 1355: pay_ca_eoy_rl2_trans_info_v

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

Line 1424: pay_ca_eoy_rl2_trans_info_v tran

1420: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
1421: nvl(emp.negative_balance_flag, 'N'),
1422: emp.person_id
1423: FROM pay_ca_eoy_rl2_employee_info_v emp,
1424: pay_ca_eoy_rl2_trans_info_v tran
1425: WHERE emp.assignment_action_id = p_asg_action_id
1426: AND emp.payroll_action_id = tran.payroll_action_id;
1427: /* Commented for bug 8888411
1428: AND nvl(emp.rl2_source_of_income,1) not in --6525968

Line 2885: FROM pay_ca_eoy_rl2_trans_info_v

2881: nvl(employer_add_line2,' '),
2882: nvl(employer_city,' '),
2883: nvl(employer_province,' '),
2884: nvl(employer_postal_code,' ')
2885: FROM pay_ca_eoy_rl2_trans_info_v
2886: WHERE business_group_id = p_business_group_id
2887: AND payroll_action_id = p_pact_id;
2888:
2889: BEGIN

Line 3086: pay_ca_eoy_rl2_trans_info_v tran

3082: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
3083: nvl(emp.negative_balance_flag, 'N'),
3084: emp.person_id
3085: FROM pay_ca_eoy_rl2_employee_info_v emp,
3086: pay_ca_eoy_rl2_trans_info_v tran
3087: WHERE emp.assignment_action_id = p_asg_action_id
3088: AND emp.assignment_id = p_assignment_id
3089: AND emp.payroll_action_id = tran.payroll_action_id;
3090: