APPS.PAY_JP_IWHT_REPORT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 591: FROM pay_assignment_actions PAA

587: --
588:
589: SELECT assignment_id
590: INTO ln_assignment_id
591: FROM pay_assignment_actions PAA
592: WHERE PAA.assignment_action_id = ln_cur_assact;
593:
594: get_cp_xml(ln_assignment_id,l_final_xml_string);
595: --

Line 726: ,pay_assignment_actions PAS

722: SELECT DISTINCT PJIWTV.assignment_id
723: ,PJIWTV.term_payment_date
724: FROM per_assignments_f PAA
725: ,per_people_f PAP
726: ,pay_assignment_actions PAS
727: ,pay_jp_iwht_tax_v PJIWTV
728: ,per_periods_of_service PPOF
729: ,pay_population_ranges PPR
730: ,pay_payroll_actions PPA

Line 764: ,pay_assignment_actions PAS

760: SELECT DISTINCT PJIWTV.assignment_id
761: ,PJIWTV.term_payment_date
762: FROM per_assignments_f PAA
763: ,per_people_f PAP
764: ,pay_assignment_actions PAS
765: ,pay_jp_iwht_tax_v PJIWTV
766: ,per_periods_of_service PPOF
767: ,hr_all_organization_units HAOU
768: WHERE PAA.person_id = PAP.person_id

Line 788: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;

784: AND NVL(p_termination_date_to,PPOF.actual_termination_date)
785: OR --PPOF.actual_termination_date IS NULL -- commented for the bug #9527198
786: (p_termination_date_from IS NULL AND p_termination_date_to IS NULL));
787: --
788: ln_assact pay_assignment_actions.assignment_action_id%TYPE ;
789: lc_proc_name VARCHAR2(60);
790: lc_legislative_parameters VARCHAR2(2000);
791: ln_ass_set_id NUMBER;
792: lc_include_flag VARCHAR2(1);

Line 845: SELECT pay_assignment_actions_s.nextval

841: IF (NVL(ln_ass_set_id ,0) = 0) THEN
842: -- NO assignment set passed as parameter
843: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
844: --
845: SELECT pay_assignment_actions_s.nextval
846: INTO ln_assact
847: FROM dual;
848: hr_nonrun_asact.insact (ln_assact
849: ,lr_assact.assignment_id

Line 863: SELECT pay_assignment_actions_s.nextval

859: ,p_populate_fs_flag => 'Y' -- #Bug No 9508028
860: );
861: IF lc_include_flag = 'Y' THEN
862: --
863: SELECT pay_assignment_actions_s.nextval
864: INTO ln_assact
865: FROM dual;
866: hr_nonrun_asact.insact (ln_assact
867: ,lr_assact.assignment_id

Line 895: SELECT pay_assignment_actions_s.nextval

891: IF (NVL(ln_ass_set_id ,0) = 0) THEN
892: -- NO assignment set passed as parameter
893: hr_utility.trace ('ass_id = '||lr_assact.assignment_id);
894: --
895: SELECT pay_assignment_actions_s.nextval
896: INTO ln_assact
897: FROM dual;
898: hr_nonrun_asact.insact( ln_assact
899: ,lr_assact.assignment_id

Line 912: SELECT pay_assignment_actions_s.nextval

908: ,p_effective_date => lr_assact.term_payment_date
909: ,p_populate_fs_flag => 'Y' -- #Bug No 9508028
910: );
911: IF lc_include_flag = 'Y' THEN
912: SELECT pay_assignment_actions_s.nextval
913: INTO ln_assact
914: FROM dual;
915: hr_nonrun_asact.insact( ln_assact
916: ,lr_assact.assignment_id

Line 1099: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

1095: l_common_xml CLOB;
1096: l_xml_begin VARCHAR2(200);
1097: seq NUMBER;
1098: seque NUMBER;
1099: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1100: lc_value1 VARCHAR2(10);
1101: lc_value2 VARCHAR2(10);
1102: lc_value3 VARCHAR2(10);
1103:

Line 1519: ,pay_assignment_actions PAA

1515: -- Added above for the Bug # 9569078
1516:
1517: sqlstr := ' SELECT PAA.rowid
1518: FROM per_assignments_f PAF
1519: ,pay_assignment_actions PAA
1520: ,per_people_f PPF
1521: ,hr_all_organization_units_tl HAOUT
1522: ,hr_all_organization_units HAOU
1523: ,per_periods_of_service PPS