APPS.PAY_NO_PAYPROC dependencies on PER_ALL_ASSIGNMENTS_F

Line 79: per_all_assignments_f asg,

75: SELECT act.assignment_action_id,
76: act.assignment_id,
77: ppp.pre_payment_id
78: FROM pay_assignment_actions act,
79: per_all_assignments_f asg,
80: pay_payroll_actions pa2,
81: pay_payroll_actions pa1,
82: pay_pre_payments ppp,
83: pay_org_payment_methods_f OPM,

Line 590: ,per_all_assignments_f paf

586: CURSOR csr_get_address(p_assignment_id number)
587: is
588: select ADDRESS_LINE1,ADDRESS_LINE2,POSTAL_CODE --,TOWN_OR_CITY
589: FROM per_addresses pad
590: ,per_all_assignments_f paf
591: ,per_all_people_f pef
592:
593: WHERE paf.assignment_id=p_assignment_id
594: and paf.person_id = pef.person_id

Line 1433: l_act_id per_all_assignments_f.assignment_id%TYPE ;

1429:
1430: --local variables
1431: l_own_ref varchar2(50);
1432: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE ;
1433: l_act_id per_all_assignments_f.assignment_id%TYPE ;
1434:
1435: /* cursor to get the emp no from the assignment_id for BETFOR22*/
1436: CURSOR csr_emp_no(v_act_id per_all_assignments_f.assignment_id%TYPE)
1437: IS

Line 1436: CURSOR csr_emp_no(v_act_id per_all_assignments_f.assignment_id%TYPE)

1432: l_asg_act_id pay_assignment_actions.assignment_action_id%TYPE ;
1433: l_act_id per_all_assignments_f.assignment_id%TYPE ;
1434:
1435: /* cursor to get the emp no from the assignment_id for BETFOR22*/
1436: CURSOR csr_emp_no(v_act_id per_all_assignments_f.assignment_id%TYPE)
1437: IS
1438: SELECT ppf.employee_number
1439: FROM per_all_people_f ppf,
1440: per_all_assignments_f paf

Line 1440: per_all_assignments_f paf

1436: CURSOR csr_emp_no(v_act_id per_all_assignments_f.assignment_id%TYPE)
1437: IS
1438: SELECT ppf.employee_number
1439: FROM per_all_people_f ppf,
1440: per_all_assignments_f paf
1441: WHERE ppf.person_id=paf.person_id
1442: AND paf.assignment_id=v_act_id;
1443:
1444:

Line 1450: per_all_assignments_f paf,

1446: CURSOR csr_emp_no_1(v_asg_act_id pay_assignment_actions.assignment_action_id%TYPE)
1447: IS
1448: SELECT ppf.employee_number
1449: FROM per_all_people_f ppf,
1450: per_all_assignments_f paf,
1451: pay_assignment_actions paa
1452: WHERE ppf.person_id=paf.person_id
1453: AND paf.assignment_id=paa.assignment_id
1454: AND paa.assignment_action_id=v_asg_act_id;