APPS.PAY_NO_RULES dependencies on PAY_ACTION_INFORMATION

Line 661: l_data pay_action_information.action_information1%TYPE;

657: AND descriptive_flex_context_code = p_context_code
658: AND application_column_name = UPPER (p_node);
659: --
660: l_tag_name VARCHAR2(500);
661: l_data pay_action_information.action_information1%TYPE;
662: l_node pay_action_information.action_information1%TYPE;
663: --
664: BEGIN
665: --

Line 662: l_node pay_action_information.action_information1%TYPE;

658: AND application_column_name = UPPER (p_node);
659: --
660: l_tag_name VARCHAR2(500);
661: l_data pay_action_information.action_information1%TYPE;
662: l_node pay_action_information.action_information1%TYPE;
663: --
664: BEGIN
665: --
666: IF p_node_type = 'CS' THEN

Line 748: FROM pay_action_information pai

744: ,pai.action_information6 uom
745: --,pai1.action_information8 record_count
746: --,sum(pai1.action_information4) value
747: ,pai1.action_information4 value
748: FROM pay_action_information pai
749: ,pay_action_information pai1
750: ,pay_assignment_actions paa
751: WHERE pai.action_context_type = 'PA'
752: AND pai.action_information_category = p_pa_category

Line 749: ,pay_action_information pai1

745: --,pai1.action_information8 record_count
746: --,sum(pai1.action_information4) value
747: ,pai1.action_information4 value
748: FROM pay_action_information pai
749: ,pay_action_information pai1
750: ,pay_assignment_actions paa
751: WHERE pai.action_context_type = 'PA'
752: AND pai.action_information_category = p_pa_category
753: AND pai1.action_context_type = 'AAP'

Line 798: FROM pay_action_information pai

794: ,pai1.action_information12 bal_val_ytd
795: ,pai.action_information10 hol_basis_text
796: ,pai.action_information11 tax_basis_text
797: ,pai.action_information12 ele_class
798: FROM pay_action_information pai
799: ,pay_action_information pai1
800: ,pay_assignment_actions paa
801: WHERE pai.action_context_type = 'PA'
802: AND pai.action_information_category = p_pa_category

Line 799: ,pay_action_information pai1

795: ,pai.action_information10 hol_basis_text
796: ,pai.action_information11 tax_basis_text
797: ,pai.action_information12 ele_class
798: FROM pay_action_information pai
799: ,pay_action_information pai1
800: ,pay_assignment_actions paa
801: WHERE pai.action_context_type = 'PA'
802: AND pai.action_information_category = p_pa_category
803: AND pai1.action_context_type = 'AAP'

Line 834: FROM pay_action_information pai

830: ,pai.action_information6 uom
831: --,pai1.action_information8 record_count
832: --,sum(pai1.action_information4) value
833: ,pai1.action_information4 value
834: FROM pay_action_information pai
835: ,pay_action_information pai1
836: ,pay_assignment_actions paa
837: WHERE pai.action_context_type = 'PA'
838: AND pai.action_information_category = p_pa_category

Line 835: ,pay_action_information pai1

831: --,pai1.action_information8 record_count
832: --,sum(pai1.action_information4) value
833: ,pai1.action_information4 value
834: FROM pay_action_information pai
835: ,pay_action_information pai1
836: ,pay_assignment_actions paa
837: WHERE pai.action_context_type = 'PA'
838: AND pai.action_information_category = p_pa_category
839: AND pai1.action_context_type = 'AAP'

Line 884: FROM pay_action_information pai

880: ,pai1.action_information12 bal_val_ytd
881: ,pai.action_information10 hol_basis_text
882: ,pai.action_information11 tax_basis_text
883: ,pai.action_information12 ele_class
884: FROM pay_action_information pai
885: ,pay_action_information pai1
886: ,pay_assignment_actions paa
887: WHERE pai.action_context_type = 'PA'
888: AND pai.action_information_category = p_pa_category

Line 885: ,pay_action_information pai1

881: ,pai.action_information10 hol_basis_text
882: ,pai.action_information11 tax_basis_text
883: ,pai.action_information12 ele_class
884: FROM pay_action_information pai
885: ,pay_action_information pai1
886: ,pay_assignment_actions paa
887: WHERE pai.action_context_type = 'PA'
888: AND pai.action_information_category = p_pa_category
889: AND pai1.action_context_type = 'AAP'

Line 922: ,pay_action_information pai

918: --,pai.effective_date payment_date
919: ,ptp.default_dd_date payment_date
920: FROM per_time_periods ptp
921: ,pay_payrolls_f ppf
922: ,pay_action_information pai
923: WHERE ppf.payroll_id = ptp.payroll_id
924: AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
925: AND ptp.time_period_id = pai.action_information16
926: AND pai.action_context_type = 'AAP'